UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z/8PZO0505KgNnXC1xaKazqm4l0wZTwBXWjDzbVGkP8='
WHERE
key_id = 'aac6997e92e3cbe2b80d80cb165fcc6aa5e11a5dececfdc3cd6aedaad2413235'
AND (
token = 'z/8PZO0505KgNnXC1xaKazqm4l0wZTwBXWjDzbVGkP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)