UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pir+VMASx4zN4nmjTchOFHD11WvPwnaWK9RVm3hc1tQ='
WHERE
key_id = 'd8632eb0582155b7b5e5d482b7fc39501a36f24d745639668209ddd3528fc433'
AND (
token = 'Pir+VMASx4zN4nmjTchOFHD11WvPwnaWK9RVm3hc1tQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)