UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+9TMiXnx+xen7j5ttrbkgPB/W4LyKlpG1BDe5RvwZ8='
WHERE
key_id = '7fe72a08114900c5eec0e9fc6fc0ed942fd14147dcf6d28b141f176a6e90da7c'
AND (
token = 'Z+9TMiXnx+xen7j5ttrbkgPB/W4LyKlpG1BDe5RvwZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)