UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8pHBsqVsqfkRx+TZK7+zeoRzsa16zxwUDBES5q3C9Q='
WHERE
key_id = 'f92b24a4f25d1b658a1895a9cd7478f6feea9aa4673982171ef1b33cfb0bc3dc'
AND (
token = 'k8pHBsqVsqfkRx+TZK7+zeoRzsa16zxwUDBES5q3C9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)