UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AVoFE3zyAjjNjy6DJPcW0R/5z3JKKdmpBroDzb6Jc3U='
WHERE
key_id = '8e6317f1d4a51e1ca5f4bd3aa8f385c31d3ce61f9bb4981788d1f0a37b7eaae6'
AND (
token = 'AVoFE3zyAjjNjy6DJPcW0R/5z3JKKdmpBroDzb6Jc3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)