UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SgysFFkqF3doEAWYcKdsZXA8SyljEOxhu9x54Q1LwEw='
WHERE
key_id = '8d86643a24a1684206b21cfc78ff6212ec3d9fc10ba54cdceb5b16bf3b5e3813'
AND (
token = 'SgysFFkqF3doEAWYcKdsZXA8SyljEOxhu9x54Q1LwEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)