UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zATSIwhAA35aFNW8Dp7TlfD/lsMrvc8uxf+wZ3f9Pm0='
WHERE
key_id = 'c69142ced5d7f037621643c61066b7ea41c32112c2f20759030434abbe533343'
AND (
token = 'zATSIwhAA35aFNW8Dp7TlfD/lsMrvc8uxf+wZ3f9Pm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)