UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D0gIEEszuaCS99x12zFydaqbSobUT5SAxmO5FkGOR/s='
WHERE
key_id = 'bea74a034c6cd7c93faa5daf4b7113f7ad046e8ed3638003fb8372288b755ca1'
AND (
token = 'D0gIEEszuaCS99x12zFydaqbSobUT5SAxmO5FkGOR/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)