UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VSBefOJX6J2ZMWeKxO8mnJRhoglrgb2lPBF39rR6VWU='
WHERE
key_id = '837d68002f2536259c688b551b4d35bee4b66a8ec7c3a3fbf403c6e955678c50'
AND (
token = 'VSBefOJX6J2ZMWeKxO8mnJRhoglrgb2lPBF39rR6VWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)