UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0wYbZlCRMAECMV0In8RCgIvvapVdGesOItmG6pA9M6Q='
WHERE
key_id = 'b983a60349b6081c377ed7c38d32bd92bf1298e0507dfb5d5893b92fe464bf15'
AND (
token = '0wYbZlCRMAECMV0In8RCgIvvapVdGesOItmG6pA9M6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)