UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8XiFkYZ6MH53STiQndHIkD7DBHbnEux2XK0SSbv0G0='
WHERE
key_id = '8bb679927bfd2c939eb60280054acb7d6d4e852aeabbec2f65d6525987452d48'
AND (
token = 'X8XiFkYZ6MH53STiQndHIkD7DBHbnEux2XK0SSbv0G0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)