UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dIX9I6+jslyioXBkPIhhvI3dRAPO3S7CpLeaz+id8g='
WHERE
key_id = '37498db1044090bb4dcb597ec6e8da779cb6795ad43f52c14c4dbb23532a0498'
AND (
token = '0dIX9I6+jslyioXBkPIhhvI3dRAPO3S7CpLeaz+id8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)