UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZYd0AZEuo9OLvOr9o7HBOBR8pCWKSJykAQtItFRgCk='
WHERE
key_id = '727b8c04c849b8cc359e92eb94ae4388d93954f866d4888f8ad99268896019ec'
AND (
token = 'KZYd0AZEuo9OLvOr9o7HBOBR8pCWKSJykAQtItFRgCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)