UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z2U5obig4KibSbFUJc/NqiXiPyyE1lkmYtPQAxFHhtc='
WHERE
key_id = 'a9563f4225840bc277157841b6b99dfbf0b84427f704a9b37401d38e710521c1'
AND (
token = 'Z2U5obig4KibSbFUJc/NqiXiPyyE1lkmYtPQAxFHhtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)