UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G2fZvNkARK+qzIyv1hFhU4ynYMtfdZKI0HQAAbxvquU='
WHERE
key_id = '4493739bac79918c45f5a0ef40cc4ae22164c1a20610949e905f700633f62553'
AND (
token = 'G2fZvNkARK+qzIyv1hFhU4ynYMtfdZKI0HQAAbxvquU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)