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