UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pSydGHDK33sDu9GcNqIcYiQjzVF7wy0d8yM+zhAmHmw='
WHERE
key_id = '14d8f4990511304fe347edde9434364c8a501763fc8ee7218226121fad39e1f0'
AND (
token = 'pSydGHDK33sDu9GcNqIcYiQjzVF7wy0d8yM+zhAmHmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)