UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Joj30IJb8kYVgcEPdyFiJGo7M5+o3CbtSucz3vqghGc='
WHERE
key_id = '643b01fcc1561f88eb27c01941b2e717e1278905a20ca05e7d840ec5a9d0733d'
AND (
token = 'Joj30IJb8kYVgcEPdyFiJGo7M5+o3CbtSucz3vqghGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)