UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mk3lybKG4Q7fJowpmF4e7XOUj0myLUNn5qtFN6vh0K0='
WHERE
key_id = 'e0a95bbbc0c60d965f818d114a0f437c6f9eb746b2e66319a1f513518626ff48'
AND (
token = 'mk3lybKG4Q7fJowpmF4e7XOUj0myLUNn5qtFN6vh0K0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)