UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vbSnnLcxPD00nm1k4QcU0a3Lhs07ETNLty65trr0zqs='
WHERE
key_id = 'c599bd4648ed698f10d9ee4536c17bb67047656a0dcdef08a00b22dc60b144d3'
AND (
token = 'vbSnnLcxPD00nm1k4QcU0a3Lhs07ETNLty65trr0zqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)