UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gB3okf074jVJDDQabwTA5sVtydjAujbdqmcqZLZr5Co='
WHERE
key_id = '675888a48216154cf8e71078c5ea706ca9aba48e8aeb392efc3263900d929132'
AND (
token = 'gB3okf074jVJDDQabwTA5sVtydjAujbdqmcqZLZr5Co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)