UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1pYRBfb3rSgzAb+nMXbeTmxasGgncv1thFKidwl/tcM='
WHERE
key_id = '7f511edc457897cb9c2e3df46c7996a8ec0cf0003078bc2e2d29b38d2795680c'
AND (
token = '1pYRBfb3rSgzAb+nMXbeTmxasGgncv1thFKidwl/tcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)