UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hYl30MpoqaZszO+brYogFtOztPjRXEh4S4fB18AQwPc='
WHERE
key_id = '7a67ee6e2a8d135a87bf9b1806bd04720e5b84e5f4f67e08f83016f500f96922'
AND (
token = 'hYl30MpoqaZszO+brYogFtOztPjRXEh4S4fB18AQwPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)