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