UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uc0vmV9cAYGW+M/GsnBtZU6JK0DihHhu2pXWdY14Sts='
WHERE
key_id = '7a78f6bfedebb8e675b96625d472150e7e6b9506c54cc7023a449242a2d57240'
AND (
token = 'uc0vmV9cAYGW+M/GsnBtZU6JK0DihHhu2pXWdY14Sts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)