UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zs4Y8cfT23id5OQHLTOurtcish9/60WDPWIGCu/XE94='
WHERE
key_id = '812460393ad87ef1e16ec4ba9693c40f3a33789b44eeb7f9be60dc083b7c02dc'
AND (
token = 'Zs4Y8cfT23id5OQHLTOurtcish9/60WDPWIGCu/XE94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)