UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7RINbGh/7RYcJOGwt3ZqbmCgx/aVLmnB0L8gwZlbQc0='
WHERE
key_id = '6059934bb28244e2e9a8fe69730d8c793656f80a4078e7c52db9b27c64e8b1db'
AND (
token = '7RINbGh/7RYcJOGwt3ZqbmCgx/aVLmnB0L8gwZlbQc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)