UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aWrTjoPEhlKJnl4uQ9bv3LY1s4KKZQjIuC1rqZRChfs='
WHERE
key_id = '7e34210f071801e872942c66ec1ce523d15236071e657b3cd07b4fcc1ea48357'
AND (
token = 'aWrTjoPEhlKJnl4uQ9bv3LY1s4KKZQjIuC1rqZRChfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)