UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pf/ztYZrQe6B1ZthOxblKSN15cnrjLkE4LviPiHaU38='
WHERE
key_id = 'dcc7a2481d9f441ac23647ebd7b5270763f9f3ac43ae377166552be9b9a53edf'
AND (
token = 'Pf/ztYZrQe6B1ZthOxblKSN15cnrjLkE4LviPiHaU38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)