UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZOF9Mpb4YEcu18zUbT9mtusRqM006v3TJtkV8aa49Ho='
WHERE
key_id = 'aaf3539011aa0960ada8888d03585a7331af20fea003403cb0812abf2ee410c2'
AND (
token = 'ZOF9Mpb4YEcu18zUbT9mtusRqM006v3TJtkV8aa49Ho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)