UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rk+C9X1ZU2oPi0ozP0B656BnNelrI6WyeGJozkk04v8='
WHERE
key_id = 'e3062e31176f2fd2a86b0bc5f84866637a8a1d4800d297d9ce592c1206ed41a9'
AND (
token = 'Rk+C9X1ZU2oPi0ozP0B656BnNelrI6WyeGJozkk04v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)