UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EdbAevU5J8hw8Tu0j7+eo7rLbkDPncgCp54f3JUQzg0='
WHERE
key_id = 'cf9066716a80bb317a6002de6a92ee66a0027e233edfc9eef5dda3211a7b773a'
AND (
token = 'EdbAevU5J8hw8Tu0j7+eo7rLbkDPncgCp54f3JUQzg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)