UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iFgWZS9G4dFRNUv59haC1O/XNtcG3K4d7+DoOCroibs='
WHERE
key_id = 'db894f0bfd5c80015464514e2f32634b4942f5706cba0b7765f64bfd4d8ea63b'
AND (
token = 'iFgWZS9G4dFRNUv59haC1O/XNtcG3K4d7+DoOCroibs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)