UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xzn+m3/Et+6qiPsWvdII0Oq817IR3fRXLRkJk4jZQZg='
WHERE
key_id = 'b7bd69212c8764d5fb030405b11070f56a3d29b20710a8bcd21fbf3195e66c5d'
AND (
token = 'Xzn+m3/Et+6qiPsWvdII0Oq817IR3fRXLRkJk4jZQZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)