UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5a7IIHiIKIdBzzOJV6ia9kMUZA6fv/o/QW7rp5ijuEo='
WHERE
key_id = 'daba2ee5c3c7e8a8bf3fef43cd885a35a345f01f796581d7d31635aa5e42a2a5'
AND (
token = '5a7IIHiIKIdBzzOJV6ia9kMUZA6fv/o/QW7rp5ijuEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)